{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import tushare as ts  \n",
    "import pandas as pd  \n",
    "from sqlalchemy import create_engine  \n",
    "import sqlalchemy\n",
    "import mysql.connector\n",
    "try:\n",
    "    conn = mysql.connector.connect(user='diagnose_report', password='launch@1234',\n",
    "                                   host='rm-wz9v9e07mh753tk321o.mysql.rds.aliyuncs.com',\n",
    "                                   database='car_spider')\n",
    "except mysql.connector.Error as err:\n",
    "    if err.errno == errorcode.ER_ACCESS_DENIED_ERROR:\n",
    "        print(\"Something is wrong with your user name or password\")\n",
    "    elif err.errno == errorcode.ER_BAD_DB_ERROR:\n",
    "        print(\"Database does not exist\")\n",
    "    else:\n",
    "        print(err)\n",
    "cursor = conn.cursor()\n",
    "cursor.execute(\"select notice_type,brand,curb_weight,Wheelbase,car_length,car_width,car_height,Displacement,power,replace(vin,'/r',','),car_factory from bssoz_notice_jc\")\n",
    "results = cursor.fetchall()\n",
    "jc = pd.DataFrame(results,columns=['notice_type','brand','curb_weight','Wheelbase','car_length','car_width','car_height','Displacement','power','vin','car_factory'])\n",
    "cursor.execute(\"select notice_type,brand,curb_weight,Wheelbase,car_length,car_width,car_height,Displacement,power,replace(vin,'/r',','),car_factory from bssoz_notice_suv\")\n",
    "results = cursor.fetchall()\n",
    "suv = pd.DataFrame(results,columns=['notice_type','brand','curb_weight','Wheelbase','car_length','car_width','car_height','Displacement','power','vin','car_factory'])\n",
    "suv = suv.drop([8682,8723,8857,8858,9948,9949,10086,10202,10341,10342,10343,10361,10386])\n",
    "all1 = jc.append(suv)\n",
    "cursor.execute(\"select `factory`,`brand`,`style`,`style_1`,`长×宽×高[mm]`,`轴距[mm]`,`整备质量[kg]`,`engine_displacement`,`最大功率[kW]` from car_price_detail\")\n",
    "results = cursor.fetchall()\n",
    "price = pd.DataFrame(results,columns=['factory','brand','style','style_1','长×宽×高[mm]','轴距[mm]','整备质量[kg]','engine_displacement','最大功率[kW]'])\n",
    "cursor.execute(\"select `厂商`,`品牌`,`车系`,`车型`,`长×宽×高[mm]`,`轴距[mm]`,`整备质量[kg]`,`排量(mL)`,`最大功率[kW]` from car_price_detail_stop\")\n",
    "results = cursor.fetchall()\n",
    "price2 = pd.DataFrame(results,columns=['factory','brand','style','style_1','长×宽×高[mm]','轴距[mm]','整备质量[kg]','engine_displacement','最大功率[kW]'])\n",
    "cursor.execute(\"select `厂商`,`品牌`,`车系`,`车型`,`长×宽×高[mm]`,`轴距[mm]`,`整备质量[kg]`,`排量(mL)`,`最大功率[kW]` from car_price_detail_stop_1\")\n",
    "results = cursor.fetchall()\n",
    "price3 = pd.DataFrame(results,columns=['factory','brand','style','style_1','长×宽×高[mm]','轴距[mm]','整备质量[kg]','engine_displacement','最大功率[kW]'])\n",
    "price = price.append(price2)\n",
    "price = price.append(price3)\n",
    "conn.commit()\n",
    "cursor.close()\n",
    "conn.close()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [],
   "source": [
    "LSG_price = price[(price['brand']=='北汽绅宝')|(price['brand']=='北汽幻速')|(price['brand']=='北汽威旺')|(price['brand']=='北汽制造')|(price['brand']=='北汽道达')|(price['brand']=='北汽新能源')|(price['brand']=='北京')|(price['brand']=='北汽昌河')]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['北汽绅宝', '北汽幻速', '北汽威旺', '北汽昌河>>', '北汽昌河新能源>>', '北汽制造', '北汽道达',\n",
       "       '北汽新能源', '北京'], dtype=object)"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "LSG_price.factory.unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [],
   "source": [
    "all1['3']=all1['vin'].apply(lambda x :x[:3])\n",
    "LSG = all1[(all1['3']=='LNB')|(all1['3']=='LKC')]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>notice_type</th>\n",
       "      <th>brand_x</th>\n",
       "      <th>curb_weight</th>\n",
       "      <th>Wheelbase</th>\n",
       "      <th>car_length</th>\n",
       "      <th>car_width</th>\n",
       "      <th>car_height</th>\n",
       "      <th>Displacement</th>\n",
       "      <th>power</th>\n",
       "      <th>vin</th>\n",
       "      <th>car_factory</th>\n",
       "      <th>3</th>\n",
       "      <th>轴距[mm]</th>\n",
       "      <th>长×宽×高[mm]</th>\n",
       "      <th>brand_y</th>\n",
       "      <th>style</th>\n",
       "      <th>factory</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>CH7151CB92</td>\n",
       "      <td>昌河</td>\n",
       "      <td>1245</td>\n",
       "      <td>2672</td>\n",
       "      <td>4620</td>\n",
       "      <td>1810</td>\n",
       "      <td>1485</td>\n",
       "      <td>1499</td>\n",
       "      <td>85</td>\n",
       "      <td>LKCAA5AD×××××××××</td>\n",
       "      <td>江西昌河汽车有限责任公司</td>\n",
       "      <td>LKC</td>\n",
       "      <td>2672</td>\n",
       "      <td>4620x1810x1485</td>\n",
       "      <td>北汽昌河</td>\n",
       "      <td>昌河A6</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>CH7151CB91</td>\n",
       "      <td>昌河</td>\n",
       "      <td>1245</td>\n",
       "      <td>2672</td>\n",
       "      <td>4620</td>\n",
       "      <td>1810</td>\n",
       "      <td>1485</td>\n",
       "      <td>1499</td>\n",
       "      <td>85</td>\n",
       "      <td>LKCAA5AD×××××××××</td>\n",
       "      <td>江西昌河汽车有限责任公司</td>\n",
       "      <td>LKC</td>\n",
       "      <td>2672</td>\n",
       "      <td>4620x1810x1485</td>\n",
       "      <td>北汽昌河</td>\n",
       "      <td>昌河A6</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>CH7151CB21</td>\n",
       "      <td>昌河</td>\n",
       "      <td>1210</td>\n",
       "      <td>2672</td>\n",
       "      <td>4620</td>\n",
       "      <td>1810</td>\n",
       "      <td>1485</td>\n",
       "      <td>1499</td>\n",
       "      <td>85</td>\n",
       "      <td>LKCAA5AD×××××××××</td>\n",
       "      <td>江西昌河汽车有限责任公司</td>\n",
       "      <td>LKC</td>\n",
       "      <td>2672</td>\n",
       "      <td>4620x1810x1485</td>\n",
       "      <td>北汽昌河</td>\n",
       "      <td>昌河A6</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>CH7151CB22</td>\n",
       "      <td>昌河</td>\n",
       "      <td>1210</td>\n",
       "      <td>2672</td>\n",
       "      <td>4620</td>\n",
       "      <td>1810</td>\n",
       "      <td>1485</td>\n",
       "      <td>1499</td>\n",
       "      <td>85</td>\n",
       "      <td>LKCAA5AD×××××××××</td>\n",
       "      <td>江西昌河汽车有限责任公司</td>\n",
       "      <td>LKC</td>\n",
       "      <td>2672</td>\n",
       "      <td>4620x1810x1485</td>\n",
       "      <td>北汽昌河</td>\n",
       "      <td>昌河A6</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>CH7151CB92</td>\n",
       "      <td>昌河</td>\n",
       "      <td>1245</td>\n",
       "      <td>2672</td>\n",
       "      <td>4620</td>\n",
       "      <td>1810</td>\n",
       "      <td>1485</td>\n",
       "      <td>1499</td>\n",
       "      <td>85</td>\n",
       "      <td>LKCAA5AD×××××××××</td>\n",
       "      <td>江西昌河汽车有限责任公司</td>\n",
       "      <td>LKC</td>\n",
       "      <td>2672</td>\n",
       "      <td>4620x1810x1485</td>\n",
       "      <td>北汽昌河</td>\n",
       "      <td>昌河A6</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>CH7151CB91</td>\n",
       "      <td>昌河</td>\n",
       "      <td>1245</td>\n",
       "      <td>2672</td>\n",
       "      <td>4620</td>\n",
       "      <td>1810</td>\n",
       "      <td>1485</td>\n",
       "      <td>1499</td>\n",
       "      <td>85</td>\n",
       "      <td>LKCAA5AD×××××××××</td>\n",
       "      <td>江西昌河汽车有限责任公司</td>\n",
       "      <td>LKC</td>\n",
       "      <td>2672</td>\n",
       "      <td>4620x1810x1485</td>\n",
       "      <td>北汽昌河</td>\n",
       "      <td>昌河A6</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>CH7151CB21</td>\n",
       "      <td>昌河</td>\n",
       "      <td>1210</td>\n",
       "      <td>2672</td>\n",
       "      <td>4620</td>\n",
       "      <td>1810</td>\n",
       "      <td>1485</td>\n",
       "      <td>1499</td>\n",
       "      <td>85</td>\n",
       "      <td>LKCAA5AD×××××××××</td>\n",
       "      <td>江西昌河汽车有限责任公司</td>\n",
       "      <td>LKC</td>\n",
       "      <td>2672</td>\n",
       "      <td>4620x1810x1485</td>\n",
       "      <td>北汽昌河</td>\n",
       "      <td>昌河A6</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>CH7151CB22</td>\n",
       "      <td>昌河</td>\n",
       "      <td>1210</td>\n",
       "      <td>2672</td>\n",
       "      <td>4620</td>\n",
       "      <td>1810</td>\n",
       "      <td>1485</td>\n",
       "      <td>1499</td>\n",
       "      <td>85</td>\n",
       "      <td>LKCAA5AD×××××××××</td>\n",
       "      <td>江西昌河汽车有限责任公司</td>\n",
       "      <td>LKC</td>\n",
       "      <td>2672</td>\n",
       "      <td>4620x1810x1485</td>\n",
       "      <td>北汽昌河</td>\n",
       "      <td>昌河A6</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>CH7151CB22</td>\n",
       "      <td>昌河</td>\n",
       "      <td>1210</td>\n",
       "      <td>2672</td>\n",
       "      <td>4620</td>\n",
       "      <td>1810</td>\n",
       "      <td>1485</td>\n",
       "      <td>1499</td>\n",
       "      <td>85</td>\n",
       "      <td>LKCAA5AD×××××××××</td>\n",
       "      <td>江西昌河汽车有限责任公司</td>\n",
       "      <td>LKC</td>\n",
       "      <td>2672</td>\n",
       "      <td>4620x1810x1485</td>\n",
       "      <td>北汽昌河</td>\n",
       "      <td>昌河A6</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>CH7151CB21</td>\n",
       "      <td>昌河</td>\n",
       "      <td>1210</td>\n",
       "      <td>2672</td>\n",
       "      <td>4620</td>\n",
       "      <td>1810</td>\n",
       "      <td>1485</td>\n",
       "      <td>1499</td>\n",
       "      <td>85</td>\n",
       "      <td>LKCAA5AD×××××××××</td>\n",
       "      <td>江西昌河汽车有限责任公司</td>\n",
       "      <td>LKC</td>\n",
       "      <td>2672</td>\n",
       "      <td>4620x1810x1485</td>\n",
       "      <td>北汽昌河</td>\n",
       "      <td>昌河A6</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>CH7151CB91</td>\n",
       "      <td>昌河</td>\n",
       "      <td>1245</td>\n",
       "      <td>2672</td>\n",
       "      <td>4620</td>\n",
       "      <td>1810</td>\n",
       "      <td>1485</td>\n",
       "      <td>1499</td>\n",
       "      <td>85</td>\n",
       "      <td>LKCAA5AD×××××××××</td>\n",
       "      <td>江西昌河汽车有限责任公司</td>\n",
       "      <td>LKC</td>\n",
       "      <td>2672</td>\n",
       "      <td>4620x1810x1485</td>\n",
       "      <td>北汽昌河</td>\n",
       "      <td>昌河A6</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>CH7151CB92</td>\n",
       "      <td>昌河</td>\n",
       "      <td>1245</td>\n",
       "      <td>2672</td>\n",
       "      <td>4620</td>\n",
       "      <td>1810</td>\n",
       "      <td>1485</td>\n",
       "      <td>1499</td>\n",
       "      <td>85</td>\n",
       "      <td>LKCAA5AD×××××××××</td>\n",
       "      <td>江西昌河汽车有限责任公司</td>\n",
       "      <td>LKC</td>\n",
       "      <td>2672</td>\n",
       "      <td>4620x1810x1485</td>\n",
       "      <td>北汽昌河</td>\n",
       "      <td>昌河A6</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>CH7151CB22</td>\n",
       "      <td>昌河</td>\n",
       "      <td>1210</td>\n",
       "      <td>2672</td>\n",
       "      <td>4620</td>\n",
       "      <td>1810</td>\n",
       "      <td>1485</td>\n",
       "      <td>1499</td>\n",
       "      <td>85</td>\n",
       "      <td>LKCAA5AD×××××××××</td>\n",
       "      <td>江西昌河汽车有限责任公司</td>\n",
       "      <td>LKC</td>\n",
       "      <td>2672</td>\n",
       "      <td>4620x1810x1485</td>\n",
       "      <td>北汽昌河</td>\n",
       "      <td>昌河A6</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>CH7151CB92</td>\n",
       "      <td>昌河</td>\n",
       "      <td>1245</td>\n",
       "      <td>2672</td>\n",
       "      <td>4620</td>\n",
       "      <td>1810</td>\n",
       "      <td>1485</td>\n",
       "      <td>1499</td>\n",
       "      <td>85</td>\n",
       "      <td>LKCAA5AD×××××××××</td>\n",
       "      <td>江西昌河汽车有限责任公司</td>\n",
       "      <td>LKC</td>\n",
       "      <td>2672</td>\n",
       "      <td>4620x1810x1485</td>\n",
       "      <td>北汽昌河</td>\n",
       "      <td>昌河A6</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>CH7151CB21</td>\n",
       "      <td>昌河</td>\n",
       "      <td>1210</td>\n",
       "      <td>2672</td>\n",
       "      <td>4620</td>\n",
       "      <td>1810</td>\n",
       "      <td>1485</td>\n",
       "      <td>1499</td>\n",
       "      <td>85</td>\n",
       "      <td>LKCAA5AD×××××××××</td>\n",
       "      <td>江西昌河汽车有限责任公司</td>\n",
       "      <td>LKC</td>\n",
       "      <td>2672</td>\n",
       "      <td>4620x1810x1485</td>\n",
       "      <td>北汽昌河</td>\n",
       "      <td>昌河A6</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>CH7151CB91</td>\n",
       "      <td>昌河</td>\n",
       "      <td>1245</td>\n",
       "      <td>2672</td>\n",
       "      <td>4620</td>\n",
       "      <td>1810</td>\n",
       "      <td>1485</td>\n",
       "      <td>1499</td>\n",
       "      <td>85</td>\n",
       "      <td>LKCAA5AD×××××××××</td>\n",
       "      <td>江西昌河汽车有限责任公司</td>\n",
       "      <td>LKC</td>\n",
       "      <td>2672</td>\n",
       "      <td>4620x1810x1485</td>\n",
       "      <td>北汽昌河</td>\n",
       "      <td>昌河A6</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>BJ7150C5E1B</td>\n",
       "      <td>北京</td>\n",
       "      <td>1321</td>\n",
       "      <td>2650</td>\n",
       "      <td>4582</td>\n",
       "      <td>1794</td>\n",
       "      <td>1486</td>\n",
       "      <td>1499</td>\n",
       "      <td>83</td>\n",
       "      <td>LNBSCCAK×××××××××</td>\n",
       "      <td>北京汽车股份有限公司</td>\n",
       "      <td>LNB</td>\n",
       "      <td>2650</td>\n",
       "      <td>4582x1794x1486</td>\n",
       "      <td>北汽绅宝</td>\n",
       "      <td>绅宝D50</td>\n",
       "      <td>22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>BJ7151C5EB</td>\n",
       "      <td>北京</td>\n",
       "      <td>1270</td>\n",
       "      <td>2650</td>\n",
       "      <td>4582</td>\n",
       "      <td>1794</td>\n",
       "      <td>1486</td>\n",
       "      <td>1499</td>\n",
       "      <td>85</td>\n",
       "      <td>LNBSCCAH×××××××××</td>\n",
       "      <td>北京汽车股份有限公司</td>\n",
       "      <td>LNB</td>\n",
       "      <td>2650</td>\n",
       "      <td>4582x1794x1486</td>\n",
       "      <td>北汽绅宝</td>\n",
       "      <td>绅宝D50</td>\n",
       "      <td>22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>BJ7150C5EB-BSG</td>\n",
       "      <td>北京</td>\n",
       "      <td>1270</td>\n",
       "      <td>2650</td>\n",
       "      <td>4582</td>\n",
       "      <td>1794</td>\n",
       "      <td>1486</td>\n",
       "      <td>1499</td>\n",
       "      <td>83</td>\n",
       "      <td>LNBSCCAH×××××××××</td>\n",
       "      <td>北京汽车股份有限公司</td>\n",
       "      <td>LNB</td>\n",
       "      <td>2650</td>\n",
       "      <td>4582x1794x1486</td>\n",
       "      <td>北汽绅宝</td>\n",
       "      <td>绅宝D50</td>\n",
       "      <td>22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>BJ7150C5E1B-BSG</td>\n",
       "      <td>北京</td>\n",
       "      <td>1321</td>\n",
       "      <td>2650</td>\n",
       "      <td>4582</td>\n",
       "      <td>1794</td>\n",
       "      <td>1486</td>\n",
       "      <td>1499</td>\n",
       "      <td>83</td>\n",
       "      <td>LNBSCCAK×××××××××</td>\n",
       "      <td>北京汽车股份有限公司</td>\n",
       "      <td>LNB</td>\n",
       "      <td>2650</td>\n",
       "      <td>4582x1794x1486</td>\n",
       "      <td>北汽绅宝</td>\n",
       "      <td>绅宝D50</td>\n",
       "      <td>22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>BJ7152C5EMB</td>\n",
       "      <td>北京</td>\n",
       "      <td>1325</td>\n",
       "      <td>2650</td>\n",
       "      <td>4582</td>\n",
       "      <td>1794</td>\n",
       "      <td>1486</td>\n",
       "      <td>1499</td>\n",
       "      <td>110</td>\n",
       "      <td>LNBSCCAH×××××××××</td>\n",
       "      <td>北京汽车股份有限公司</td>\n",
       "      <td>LNB</td>\n",
       "      <td>2650</td>\n",
       "      <td>4582x1794x1486</td>\n",
       "      <td>北汽绅宝</td>\n",
       "      <td>绅宝D50</td>\n",
       "      <td>22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>BJ7152C5EM1B</td>\n",
       "      <td>北京</td>\n",
       "      <td>1325</td>\n",
       "      <td>2650</td>\n",
       "      <td>4582</td>\n",
       "      <td>1794</td>\n",
       "      <td>1486</td>\n",
       "      <td>1499</td>\n",
       "      <td>110</td>\n",
       "      <td>LNBSCCAH×××××××××</td>\n",
       "      <td>北京汽车股份有限公司</td>\n",
       "      <td>LNB</td>\n",
       "      <td>2650</td>\n",
       "      <td>4582x1794x1486</td>\n",
       "      <td>北汽绅宝</td>\n",
       "      <td>绅宝D50</td>\n",
       "      <td>22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>BJ7152C5EM1B</td>\n",
       "      <td>北京</td>\n",
       "      <td>1325</td>\n",
       "      <td>2650</td>\n",
       "      <td>4582</td>\n",
       "      <td>1794</td>\n",
       "      <td>1486</td>\n",
       "      <td>1499</td>\n",
       "      <td>110</td>\n",
       "      <td>LNBSCCAH×××××××××</td>\n",
       "      <td>北京汽车股份有限公司</td>\n",
       "      <td>LNB</td>\n",
       "      <td>2650</td>\n",
       "      <td>4582x1794x1486</td>\n",
       "      <td>北汽绅宝</td>\n",
       "      <td>绅宝D50</td>\n",
       "      <td>22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>BJ7152C5EM</td>\n",
       "      <td>北京</td>\n",
       "      <td>1325</td>\n",
       "      <td>2650</td>\n",
       "      <td>4582</td>\n",
       "      <td>1794</td>\n",
       "      <td>1486</td>\n",
       "      <td>1499</td>\n",
       "      <td>110</td>\n",
       "      <td>LNBSCCAH×××××××××</td>\n",
       "      <td>北京汽车股份有限公司</td>\n",
       "      <td>LNB</td>\n",
       "      <td>2650</td>\n",
       "      <td>4582x1794x1486</td>\n",
       "      <td>北汽绅宝</td>\n",
       "      <td>绅宝D50</td>\n",
       "      <td>22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>BJ7152C5EMB</td>\n",
       "      <td>北京</td>\n",
       "      <td>1325</td>\n",
       "      <td>2650</td>\n",
       "      <td>4582</td>\n",
       "      <td>1794</td>\n",
       "      <td>1486</td>\n",
       "      <td>1499</td>\n",
       "      <td>110</td>\n",
       "      <td>LNBSCCAH×××××××××</td>\n",
       "      <td>北京汽车股份有限公司</td>\n",
       "      <td>LNB</td>\n",
       "      <td>2650</td>\n",
       "      <td>4582x1794x1486</td>\n",
       "      <td>北汽绅宝</td>\n",
       "      <td>绅宝D50</td>\n",
       "      <td>22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>BJ7150C5E1</td>\n",
       "      <td>北京</td>\n",
       "      <td>1321</td>\n",
       "      <td>2650</td>\n",
       "      <td>4582</td>\n",
       "      <td>1794</td>\n",
       "      <td>1486</td>\n",
       "      <td>1499</td>\n",
       "      <td>83</td>\n",
       "      <td>LNBSCCAK×××××××××</td>\n",
       "      <td>北京汽车股份有限公司</td>\n",
       "      <td>LNB</td>\n",
       "      <td>2650</td>\n",
       "      <td>4582x1794x1486</td>\n",
       "      <td>北汽绅宝</td>\n",
       "      <td>绅宝D50</td>\n",
       "      <td>22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>BJ7150C5E1B</td>\n",
       "      <td>北京</td>\n",
       "      <td>1321</td>\n",
       "      <td>2650</td>\n",
       "      <td>4582</td>\n",
       "      <td>1794</td>\n",
       "      <td>1486</td>\n",
       "      <td>1499</td>\n",
       "      <td>83</td>\n",
       "      <td>LNBSCCAK×××××××××</td>\n",
       "      <td>北京汽车股份有限公司</td>\n",
       "      <td>LNB</td>\n",
       "      <td>2650</td>\n",
       "      <td>4582x1794x1486</td>\n",
       "      <td>北汽绅宝</td>\n",
       "      <td>绅宝D50</td>\n",
       "      <td>22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>BJ7151C5EB</td>\n",
       "      <td>北京</td>\n",
       "      <td>1270</td>\n",
       "      <td>2650</td>\n",
       "      <td>4582</td>\n",
       "      <td>1794</td>\n",
       "      <td>1486</td>\n",
       "      <td>1499</td>\n",
       "      <td>85</td>\n",
       "      <td>LNBSCCAH×××××××××</td>\n",
       "      <td>北京汽车股份有限公司</td>\n",
       "      <td>LNB</td>\n",
       "      <td>2650</td>\n",
       "      <td>4582x1794x1486</td>\n",
       "      <td>北汽绅宝</td>\n",
       "      <td>绅宝D50</td>\n",
       "      <td>22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>BJ7151C5E</td>\n",
       "      <td>北京</td>\n",
       "      <td>1270</td>\n",
       "      <td>2650</td>\n",
       "      <td>4582</td>\n",
       "      <td>1794</td>\n",
       "      <td>1486</td>\n",
       "      <td>1499</td>\n",
       "      <td>85</td>\n",
       "      <td>LNBSCCAH×××××××××</td>\n",
       "      <td>北京汽车股份有限公司</td>\n",
       "      <td>LNB</td>\n",
       "      <td>2650</td>\n",
       "      <td>4582x1794x1486</td>\n",
       "      <td>北汽绅宝</td>\n",
       "      <td>绅宝D50</td>\n",
       "      <td>22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>BJ7150C5E2</td>\n",
       "      <td>北京</td>\n",
       "      <td>1270</td>\n",
       "      <td>2650</td>\n",
       "      <td>4582</td>\n",
       "      <td>1794</td>\n",
       "      <td>1486</td>\n",
       "      <td>1499</td>\n",
       "      <td>83</td>\n",
       "      <td>LNBSCCAH×××××××××</td>\n",
       "      <td>北京汽车股份有限公司</td>\n",
       "      <td>LNB</td>\n",
       "      <td>2650</td>\n",
       "      <td>4582x1794x1486</td>\n",
       "      <td>北汽绅宝</td>\n",
       "      <td>绅宝D50</td>\n",
       "      <td>22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>647</th>\n",
       "      <td>BJ6400AJZ1Z</td>\n",
       "      <td>北京</td>\n",
       "      <td>1100</td>\n",
       "      <td>2630</td>\n",
       "      <td>4022</td>\n",
       "      <td>1600</td>\n",
       "      <td>1878</td>\n",
       "      <td>1000</td>\n",
       "      <td>45</td>\n",
       "      <td>LNBMDLAA×××××××××,LNBMCVAA×××××××××</td>\n",
       "      <td>北汽银翔汽车有限公司</td>\n",
       "      <td>LNB</td>\n",
       "      <td>2630</td>\n",
       "      <td>4022x1600x1878</td>\n",
       "      <td>北汽威旺</td>\n",
       "      <td>威旺205</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>648</th>\n",
       "      <td>BJ6400AJW1Z</td>\n",
       "      <td>北京</td>\n",
       "      <td>1100</td>\n",
       "      <td>2630</td>\n",
       "      <td>4022</td>\n",
       "      <td>1600</td>\n",
       "      <td>1878</td>\n",
       "      <td>1342</td>\n",
       "      <td>69</td>\n",
       "      <td>LNBMDLAA×××××××××,LNBMCVAA×××××××××</td>\n",
       "      <td>北汽银翔汽车有限公司</td>\n",
       "      <td>LNB</td>\n",
       "      <td>2630</td>\n",
       "      <td>4022x1600x1878</td>\n",
       "      <td>北汽威旺</td>\n",
       "      <td>威旺205</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>649</th>\n",
       "      <td>BJ6400AJZ1Z</td>\n",
       "      <td>北京</td>\n",
       "      <td>1100</td>\n",
       "      <td>2630</td>\n",
       "      <td>4022</td>\n",
       "      <td>1600</td>\n",
       "      <td>1878</td>\n",
       "      <td>1000</td>\n",
       "      <td>45</td>\n",
       "      <td>LNBMDLAA×××××××××,LNBMCVAA×××××××××</td>\n",
       "      <td>北汽银翔汽车有限公司</td>\n",
       "      <td>LNB</td>\n",
       "      <td>2630</td>\n",
       "      <td>4022x1600x1878</td>\n",
       "      <td>北汽威旺</td>\n",
       "      <td>威旺205</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>650</th>\n",
       "      <td>BJ6400AJW1A</td>\n",
       "      <td>北京</td>\n",
       "      <td>1100</td>\n",
       "      <td>2630</td>\n",
       "      <td>4022</td>\n",
       "      <td>1600</td>\n",
       "      <td>1878</td>\n",
       "      <td>1342</td>\n",
       "      <td>69</td>\n",
       "      <td>LNBMDLAA×××××××××,LNBMCVAA×××××××××</td>\n",
       "      <td>北汽银翔汽车有限公司</td>\n",
       "      <td>LNB</td>\n",
       "      <td>2630</td>\n",
       "      <td>4022x1600x1878</td>\n",
       "      <td>北汽威旺</td>\n",
       "      <td>威旺205</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>651</th>\n",
       "      <td>BJ6400AJW1Z</td>\n",
       "      <td>北京</td>\n",
       "      <td>1100</td>\n",
       "      <td>2630</td>\n",
       "      <td>4022</td>\n",
       "      <td>1600</td>\n",
       "      <td>1878</td>\n",
       "      <td>1342</td>\n",
       "      <td>69</td>\n",
       "      <td>LNBMDLAA×××××××××,LNBMCVAA×××××××××</td>\n",
       "      <td>北汽银翔汽车有限公司</td>\n",
       "      <td>LNB</td>\n",
       "      <td>2630</td>\n",
       "      <td>4022x1600x1878</td>\n",
       "      <td>北汽威旺</td>\n",
       "      <td>威旺205</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>652</th>\n",
       "      <td>BJ6400AJZ1A1</td>\n",
       "      <td>北京</td>\n",
       "      <td>1100</td>\n",
       "      <td>2630</td>\n",
       "      <td>4022</td>\n",
       "      <td>1600</td>\n",
       "      <td>1878</td>\n",
       "      <td>1000</td>\n",
       "      <td>51</td>\n",
       "      <td>LNBMDLAA×××××××××,LNBMCVAA×××××××××</td>\n",
       "      <td>北汽银翔汽车有限公司</td>\n",
       "      <td>LNB</td>\n",
       "      <td>2630</td>\n",
       "      <td>4022x1600x1878</td>\n",
       "      <td>北汽威旺</td>\n",
       "      <td>威旺205</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>653</th>\n",
       "      <td>BJ6400AJZ1A</td>\n",
       "      <td>北京</td>\n",
       "      <td>1100</td>\n",
       "      <td>2630</td>\n",
       "      <td>4022</td>\n",
       "      <td>1600</td>\n",
       "      <td>1878</td>\n",
       "      <td>1000</td>\n",
       "      <td>45</td>\n",
       "      <td>LNBMDLAA×××××××××,LNBMCVAA×××××××××</td>\n",
       "      <td>北汽银翔汽车有限公司</td>\n",
       "      <td>LNB</td>\n",
       "      <td>2630</td>\n",
       "      <td>4022x1600x1878</td>\n",
       "      <td>北汽威旺</td>\n",
       "      <td>威旺205</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>654</th>\n",
       "      <td>BJ6400AJW1L</td>\n",
       "      <td>北京</td>\n",
       "      <td>1100</td>\n",
       "      <td>2630</td>\n",
       "      <td>4022</td>\n",
       "      <td>1600</td>\n",
       "      <td>1878</td>\n",
       "      <td>1342</td>\n",
       "      <td>69〔汽油〕/60〔CNG〕</td>\n",
       "      <td>LNBMDL6A×××××××××,LNBMCV6A×××××××××</td>\n",
       "      <td>北汽银翔汽车有限公司</td>\n",
       "      <td>LNB</td>\n",
       "      <td>2630</td>\n",
       "      <td>4022x1600x1878</td>\n",
       "      <td>北汽威旺</td>\n",
       "      <td>威旺205</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>655</th>\n",
       "      <td>BJ6400AJZ1Z</td>\n",
       "      <td>北京</td>\n",
       "      <td>1100</td>\n",
       "      <td>2630</td>\n",
       "      <td>4022</td>\n",
       "      <td>1600</td>\n",
       "      <td>1878</td>\n",
       "      <td>1000</td>\n",
       "      <td>45</td>\n",
       "      <td>LNBMDLAA×××××××××,LNBMCVAA×××××××××</td>\n",
       "      <td>北汽银翔汽车有限公司</td>\n",
       "      <td>LNB</td>\n",
       "      <td>2630</td>\n",
       "      <td>4022x1600x1878</td>\n",
       "      <td>北汽威旺</td>\n",
       "      <td>威旺205</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>656</th>\n",
       "      <td>BJ6400AJW1L</td>\n",
       "      <td>北京</td>\n",
       "      <td>1100</td>\n",
       "      <td>2630</td>\n",
       "      <td>4022</td>\n",
       "      <td>1600</td>\n",
       "      <td>1878</td>\n",
       "      <td>1342</td>\n",
       "      <td>69〔汽油〕/60〔CNG〕</td>\n",
       "      <td>LNBMDL6A×××××××××,LNBMCV6A×××××××××</td>\n",
       "      <td>北汽银翔汽车有限公司</td>\n",
       "      <td>LNB</td>\n",
       "      <td>2630</td>\n",
       "      <td>4022x1600x1878</td>\n",
       "      <td>北汽威旺</td>\n",
       "      <td>威旺205</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>657</th>\n",
       "      <td>BJ6400AJW1A</td>\n",
       "      <td>北京</td>\n",
       "      <td>1100</td>\n",
       "      <td>2630</td>\n",
       "      <td>4022</td>\n",
       "      <td>1600</td>\n",
       "      <td>1878</td>\n",
       "      <td>1342</td>\n",
       "      <td>69</td>\n",
       "      <td>LNBMDLAA×××××××××,LNBMCVAA×××××××××</td>\n",
       "      <td>北汽银翔汽车有限公司</td>\n",
       "      <td>LNB</td>\n",
       "      <td>2630</td>\n",
       "      <td>4022x1600x1878</td>\n",
       "      <td>北汽威旺</td>\n",
       "      <td>威旺205</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>658</th>\n",
       "      <td>BJ6400AJZ1A1</td>\n",
       "      <td>北京</td>\n",
       "      <td>1100</td>\n",
       "      <td>2630</td>\n",
       "      <td>4022</td>\n",
       "      <td>1600</td>\n",
       "      <td>1878</td>\n",
       "      <td>1000</td>\n",
       "      <td>51</td>\n",
       "      <td>LNBMDLAA×××××××××,LNBMCVAA×××××××××</td>\n",
       "      <td>北汽银翔汽车有限公司</td>\n",
       "      <td>LNB</td>\n",
       "      <td>2630</td>\n",
       "      <td>4022x1600x1878</td>\n",
       "      <td>北汽威旺</td>\n",
       "      <td>威旺205</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>659</th>\n",
       "      <td>BJ6400AJZ1A</td>\n",
       "      <td>北京</td>\n",
       "      <td>1100</td>\n",
       "      <td>2630</td>\n",
       "      <td>4022</td>\n",
       "      <td>1600</td>\n",
       "      <td>1878</td>\n",
       "      <td>1000</td>\n",
       "      <td>45</td>\n",
       "      <td>LNBMDLAA×××××××××,LNBMCVAA×××××××××</td>\n",
       "      <td>北汽银翔汽车有限公司</td>\n",
       "      <td>LNB</td>\n",
       "      <td>2630</td>\n",
       "      <td>4022x1600x1878</td>\n",
       "      <td>北汽威旺</td>\n",
       "      <td>威旺205</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>660</th>\n",
       "      <td>BJ6400AJW1Z</td>\n",
       "      <td>北京</td>\n",
       "      <td>1100</td>\n",
       "      <td>2630</td>\n",
       "      <td>4022</td>\n",
       "      <td>1600</td>\n",
       "      <td>1878</td>\n",
       "      <td>1342</td>\n",
       "      <td>69</td>\n",
       "      <td>LNBMDLAA×××××××××,LNBMCVAA×××××××××</td>\n",
       "      <td>北汽银翔汽车有限公司</td>\n",
       "      <td>LNB</td>\n",
       "      <td>2630</td>\n",
       "      <td>4022x1600x1878</td>\n",
       "      <td>北汽威旺</td>\n",
       "      <td>威旺205</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>661</th>\n",
       "      <td>BJ6400AJW1A</td>\n",
       "      <td>北京</td>\n",
       "      <td>1100</td>\n",
       "      <td>2630</td>\n",
       "      <td>4022</td>\n",
       "      <td>1600</td>\n",
       "      <td>1878</td>\n",
       "      <td>1342</td>\n",
       "      <td>69</td>\n",
       "      <td>LNBMDLAA×××××××××,LNBMCVAA×××××××××</td>\n",
       "      <td>北汽银翔汽车有限公司</td>\n",
       "      <td>LNB</td>\n",
       "      <td>2630</td>\n",
       "      <td>4022x1600x1878</td>\n",
       "      <td>北汽威旺</td>\n",
       "      <td>威旺205</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>662</th>\n",
       "      <td>BJ6400AJZ1A1</td>\n",
       "      <td>北京</td>\n",
       "      <td>1100</td>\n",
       "      <td>2630</td>\n",
       "      <td>4022</td>\n",
       "      <td>1600</td>\n",
       "      <td>1878</td>\n",
       "      <td>1000</td>\n",
       "      <td>51</td>\n",
       "      <td>LNBMDLAA×××××××××,LNBMCVAA×××××××××</td>\n",
       "      <td>北汽银翔汽车有限公司</td>\n",
       "      <td>LNB</td>\n",
       "      <td>2630</td>\n",
       "      <td>4022x1600x1878</td>\n",
       "      <td>北汽威旺</td>\n",
       "      <td>威旺205</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>663</th>\n",
       "      <td>BJ6400AJZ1A</td>\n",
       "      <td>北京</td>\n",
       "      <td>1100</td>\n",
       "      <td>2630</td>\n",
       "      <td>4022</td>\n",
       "      <td>1600</td>\n",
       "      <td>1878</td>\n",
       "      <td>1000</td>\n",
       "      <td>45</td>\n",
       "      <td>LNBMDLAA×××××××××,LNBMCVAA×××××××××</td>\n",
       "      <td>北汽银翔汽车有限公司</td>\n",
       "      <td>LNB</td>\n",
       "      <td>2630</td>\n",
       "      <td>4022x1600x1878</td>\n",
       "      <td>北汽威旺</td>\n",
       "      <td>威旺205</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>664</th>\n",
       "      <td>BJ6390AHW1A</td>\n",
       "      <td>北京</td>\n",
       "      <td>1060</td>\n",
       "      <td>2500</td>\n",
       "      <td>3895</td>\n",
       "      <td>1600</td>\n",
       "      <td>1878</td>\n",
       "      <td>1342</td>\n",
       "      <td>69</td>\n",
       "      <td>LNBMDLAA×××××××××,LNBMCVAA×××××××××</td>\n",
       "      <td>北汽银翔汽车有限公司</td>\n",
       "      <td>LNB</td>\n",
       "      <td>2500</td>\n",
       "      <td>3895x1600x1878</td>\n",
       "      <td>北汽威旺</td>\n",
       "      <td>威旺205</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>665</th>\n",
       "      <td>BJ6390AHZ1A</td>\n",
       "      <td>北京</td>\n",
       "      <td>1060</td>\n",
       "      <td>2500</td>\n",
       "      <td>3895</td>\n",
       "      <td>1600</td>\n",
       "      <td>1878</td>\n",
       "      <td>1000</td>\n",
       "      <td>45</td>\n",
       "      <td>LNBMDLAA×××××××××,LNBMCVAA×××××××××</td>\n",
       "      <td>北汽银翔汽车有限公司</td>\n",
       "      <td>LNB</td>\n",
       "      <td>2500</td>\n",
       "      <td>3895x1600x1878</td>\n",
       "      <td>北汽威旺</td>\n",
       "      <td>威旺205</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>666</th>\n",
       "      <td>BJ6390AHW1A</td>\n",
       "      <td>北京</td>\n",
       "      <td>1060</td>\n",
       "      <td>2500</td>\n",
       "      <td>3895</td>\n",
       "      <td>1600</td>\n",
       "      <td>1878</td>\n",
       "      <td>1342</td>\n",
       "      <td>69</td>\n",
       "      <td>LNBMDLAA×××××××××,LNBMCVAA×××××××××</td>\n",
       "      <td>北汽银翔汽车有限公司</td>\n",
       "      <td>LNB</td>\n",
       "      <td>2500</td>\n",
       "      <td>3895x1600x1878</td>\n",
       "      <td>北汽威旺</td>\n",
       "      <td>威旺205</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>667</th>\n",
       "      <td>BJ6390AHZ1A</td>\n",
       "      <td>北京</td>\n",
       "      <td>1060</td>\n",
       "      <td>2500</td>\n",
       "      <td>3895</td>\n",
       "      <td>1600</td>\n",
       "      <td>1878</td>\n",
       "      <td>1000</td>\n",
       "      <td>45</td>\n",
       "      <td>LNBMDLAA×××××××××,LNBMCVAA×××××××××</td>\n",
       "      <td>北汽银翔汽车有限公司</td>\n",
       "      <td>LNB</td>\n",
       "      <td>2500</td>\n",
       "      <td>3895x1600x1878</td>\n",
       "      <td>北汽威旺</td>\n",
       "      <td>威旺205</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>668</th>\n",
       "      <td>BJ6390AHW1A</td>\n",
       "      <td>北京</td>\n",
       "      <td>1060</td>\n",
       "      <td>2500</td>\n",
       "      <td>3895</td>\n",
       "      <td>1600</td>\n",
       "      <td>1878</td>\n",
       "      <td>1342</td>\n",
       "      <td>69</td>\n",
       "      <td>LNBMDLAA×××××××××,LNBMCVAA×××××××××</td>\n",
       "      <td>北汽银翔汽车有限公司</td>\n",
       "      <td>LNB</td>\n",
       "      <td>2500</td>\n",
       "      <td>3895x1600x1878</td>\n",
       "      <td>北汽威旺</td>\n",
       "      <td>威旺205</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>669</th>\n",
       "      <td>BJ6390AHZ1A</td>\n",
       "      <td>北京</td>\n",
       "      <td>1060</td>\n",
       "      <td>2500</td>\n",
       "      <td>3895</td>\n",
       "      <td>1600</td>\n",
       "      <td>1878</td>\n",
       "      <td>1000</td>\n",
       "      <td>45</td>\n",
       "      <td>LNBMDLAA×××××××××,LNBMCVAA×××××××××</td>\n",
       "      <td>北汽银翔汽车有限公司</td>\n",
       "      <td>LNB</td>\n",
       "      <td>2500</td>\n",
       "      <td>3895x1600x1878</td>\n",
       "      <td>北汽威旺</td>\n",
       "      <td>威旺205</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>670</th>\n",
       "      <td>BJ6390AHZ1A1</td>\n",
       "      <td>北京</td>\n",
       "      <td>1060</td>\n",
       "      <td>2500</td>\n",
       "      <td>3895</td>\n",
       "      <td>1600</td>\n",
       "      <td>1878</td>\n",
       "      <td>1000</td>\n",
       "      <td>51</td>\n",
       "      <td>LNBMDLAA×××××××××,LNBMCVAA×××××××××</td>\n",
       "      <td>北汽银翔汽车有限公司</td>\n",
       "      <td>LNB</td>\n",
       "      <td>2500</td>\n",
       "      <td>3895x1600x1878</td>\n",
       "      <td>北汽威旺</td>\n",
       "      <td>威旺205</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>671</th>\n",
       "      <td>BJ6390AHW1A</td>\n",
       "      <td>北京</td>\n",
       "      <td>1060</td>\n",
       "      <td>2500</td>\n",
       "      <td>3895</td>\n",
       "      <td>1600</td>\n",
       "      <td>1878</td>\n",
       "      <td>1342</td>\n",
       "      <td>69</td>\n",
       "      <td>LNBMDLAA×××××××××,LNBMCVAA×××××××××</td>\n",
       "      <td>北汽银翔汽车有限公司</td>\n",
       "      <td>LNB</td>\n",
       "      <td>2500</td>\n",
       "      <td>3895x1600x1878</td>\n",
       "      <td>北汽威旺</td>\n",
       "      <td>威旺205</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>672</th>\n",
       "      <td>BJ6390AHZ1A</td>\n",
       "      <td>北京</td>\n",
       "      <td>1060</td>\n",
       "      <td>2500</td>\n",
       "      <td>3895</td>\n",
       "      <td>1600</td>\n",
       "      <td>1878</td>\n",
       "      <td>1000</td>\n",
       "      <td>45</td>\n",
       "      <td>LNBMDLAA×××××××××,LNBMCVAA×××××××××</td>\n",
       "      <td>北汽银翔汽车有限公司</td>\n",
       "      <td>LNB</td>\n",
       "      <td>2500</td>\n",
       "      <td>3895x1600x1878</td>\n",
       "      <td>北汽威旺</td>\n",
       "      <td>威旺205</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>673</th>\n",
       "      <td>BJ6390AHZ1A1</td>\n",
       "      <td>北京</td>\n",
       "      <td>1060</td>\n",
       "      <td>2500</td>\n",
       "      <td>3895</td>\n",
       "      <td>1600</td>\n",
       "      <td>1878</td>\n",
       "      <td>1000</td>\n",
       "      <td>51</td>\n",
       "      <td>LNBMDLAA×××××××××,LNBMCVAA×××××××××</td>\n",
       "      <td>北汽银翔汽车有限公司</td>\n",
       "      <td>LNB</td>\n",
       "      <td>2500</td>\n",
       "      <td>3895x1600x1878</td>\n",
       "      <td>北汽威旺</td>\n",
       "      <td>威旺205</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>674</th>\n",
       "      <td>BJ6390AHW1A</td>\n",
       "      <td>北京</td>\n",
       "      <td>1060</td>\n",
       "      <td>2500</td>\n",
       "      <td>3895</td>\n",
       "      <td>1600</td>\n",
       "      <td>1878</td>\n",
       "      <td>1342</td>\n",
       "      <td>69</td>\n",
       "      <td>LNBMDLAA×××××××××,LNBMCVAA×××××××××</td>\n",
       "      <td>北汽银翔汽车有限公司</td>\n",
       "      <td>LNB</td>\n",
       "      <td>2500</td>\n",
       "      <td>3895x1600x1878</td>\n",
       "      <td>北汽威旺</td>\n",
       "      <td>威旺205</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>675</th>\n",
       "      <td>BJ6390AHZ1A</td>\n",
       "      <td>北京</td>\n",
       "      <td>1060</td>\n",
       "      <td>2500</td>\n",
       "      <td>3895</td>\n",
       "      <td>1600</td>\n",
       "      <td>1878</td>\n",
       "      <td>1000</td>\n",
       "      <td>45</td>\n",
       "      <td>LNBMDLAA×××××××××,LNBMCVAA×××××××××</td>\n",
       "      <td>北汽银翔汽车有限公司</td>\n",
       "      <td>LNB</td>\n",
       "      <td>2500</td>\n",
       "      <td>3895x1600x1878</td>\n",
       "      <td>北汽威旺</td>\n",
       "      <td>威旺205</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>676</th>\n",
       "      <td>BJ6390AHZ1A1</td>\n",
       "      <td>北京</td>\n",
       "      <td>1060</td>\n",
       "      <td>2500</td>\n",
       "      <td>3895</td>\n",
       "      <td>1600</td>\n",
       "      <td>1878</td>\n",
       "      <td>1000</td>\n",
       "      <td>51</td>\n",
       "      <td>LNBMDLAA×××××××××,LNBMCVAA×××××××××</td>\n",
       "      <td>北汽银翔汽车有限公司</td>\n",
       "      <td>LNB</td>\n",
       "      <td>2500</td>\n",
       "      <td>3895x1600x1878</td>\n",
       "      <td>北汽威旺</td>\n",
       "      <td>威旺205</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>677 rows × 17 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "         notice_type brand_x curb_weight Wheelbase car_length car_width  \\\n",
       "0         CH7151CB92      昌河        1245      2672       4620      1810   \n",
       "1         CH7151CB91      昌河        1245      2672       4620      1810   \n",
       "2         CH7151CB21      昌河        1210      2672       4620      1810   \n",
       "3         CH7151CB22      昌河        1210      2672       4620      1810   \n",
       "4         CH7151CB92      昌河        1245      2672       4620      1810   \n",
       "5         CH7151CB91      昌河        1245      2672       4620      1810   \n",
       "6         CH7151CB21      昌河        1210      2672       4620      1810   \n",
       "7         CH7151CB22      昌河        1210      2672       4620      1810   \n",
       "8         CH7151CB22      昌河        1210      2672       4620      1810   \n",
       "9         CH7151CB21      昌河        1210      2672       4620      1810   \n",
       "10        CH7151CB91      昌河        1245      2672       4620      1810   \n",
       "11        CH7151CB92      昌河        1245      2672       4620      1810   \n",
       "12        CH7151CB22      昌河        1210      2672       4620      1810   \n",
       "13        CH7151CB92      昌河        1245      2672       4620      1810   \n",
       "14        CH7151CB21      昌河        1210      2672       4620      1810   \n",
       "15        CH7151CB91      昌河        1245      2672       4620      1810   \n",
       "16       BJ7150C5E1B      北京        1321      2650       4582      1794   \n",
       "17        BJ7151C5EB      北京        1270      2650       4582      1794   \n",
       "18    BJ7150C5EB-BSG      北京        1270      2650       4582      1794   \n",
       "19   BJ7150C5E1B-BSG      北京        1321      2650       4582      1794   \n",
       "20       BJ7152C5EMB      北京        1325      2650       4582      1794   \n",
       "21      BJ7152C5EM1B      北京        1325      2650       4582      1794   \n",
       "22      BJ7152C5EM1B      北京        1325      2650       4582      1794   \n",
       "23        BJ7152C5EM      北京        1325      2650       4582      1794   \n",
       "24       BJ7152C5EMB      北京        1325      2650       4582      1794   \n",
       "25        BJ7150C5E1      北京        1321      2650       4582      1794   \n",
       "26       BJ7150C5E1B      北京        1321      2650       4582      1794   \n",
       "27        BJ7151C5EB      北京        1270      2650       4582      1794   \n",
       "28         BJ7151C5E      北京        1270      2650       4582      1794   \n",
       "29        BJ7150C5E2      北京        1270      2650       4582      1794   \n",
       "..               ...     ...         ...       ...        ...       ...   \n",
       "647      BJ6400AJZ1Z      北京        1100      2630       4022      1600   \n",
       "648      BJ6400AJW1Z      北京        1100      2630       4022      1600   \n",
       "649      BJ6400AJZ1Z      北京        1100      2630       4022      1600   \n",
       "650      BJ6400AJW1A      北京        1100      2630       4022      1600   \n",
       "651      BJ6400AJW1Z      北京        1100      2630       4022      1600   \n",
       "652     BJ6400AJZ1A1      北京        1100      2630       4022      1600   \n",
       "653      BJ6400AJZ1A      北京        1100      2630       4022      1600   \n",
       "654      BJ6400AJW1L      北京        1100      2630       4022      1600   \n",
       "655      BJ6400AJZ1Z      北京        1100      2630       4022      1600   \n",
       "656      BJ6400AJW1L      北京        1100      2630       4022      1600   \n",
       "657      BJ6400AJW1A      北京        1100      2630       4022      1600   \n",
       "658     BJ6400AJZ1A1      北京        1100      2630       4022      1600   \n",
       "659      BJ6400AJZ1A      北京        1100      2630       4022      1600   \n",
       "660      BJ6400AJW1Z      北京        1100      2630       4022      1600   \n",
       "661      BJ6400AJW1A      北京        1100      2630       4022      1600   \n",
       "662     BJ6400AJZ1A1      北京        1100      2630       4022      1600   \n",
       "663      BJ6400AJZ1A      北京        1100      2630       4022      1600   \n",
       "664      BJ6390AHW1A      北京        1060      2500       3895      1600   \n",
       "665      BJ6390AHZ1A      北京        1060      2500       3895      1600   \n",
       "666      BJ6390AHW1A      北京        1060      2500       3895      1600   \n",
       "667      BJ6390AHZ1A      北京        1060      2500       3895      1600   \n",
       "668      BJ6390AHW1A      北京        1060      2500       3895      1600   \n",
       "669      BJ6390AHZ1A      北京        1060      2500       3895      1600   \n",
       "670     BJ6390AHZ1A1      北京        1060      2500       3895      1600   \n",
       "671      BJ6390AHW1A      北京        1060      2500       3895      1600   \n",
       "672      BJ6390AHZ1A      北京        1060      2500       3895      1600   \n",
       "673     BJ6390AHZ1A1      北京        1060      2500       3895      1600   \n",
       "674      BJ6390AHW1A      北京        1060      2500       3895      1600   \n",
       "675      BJ6390AHZ1A      北京        1060      2500       3895      1600   \n",
       "676     BJ6390AHZ1A1      北京        1060      2500       3895      1600   \n",
       "\n",
       "    car_height Displacement           power  \\\n",
       "0         1485         1499              85   \n",
       "1         1485         1499              85   \n",
       "2         1485         1499              85   \n",
       "3         1485         1499              85   \n",
       "4         1485         1499              85   \n",
       "5         1485         1499              85   \n",
       "6         1485         1499              85   \n",
       "7         1485         1499              85   \n",
       "8         1485         1499              85   \n",
       "9         1485         1499              85   \n",
       "10        1485         1499              85   \n",
       "11        1485         1499              85   \n",
       "12        1485         1499              85   \n",
       "13        1485         1499              85   \n",
       "14        1485         1499              85   \n",
       "15        1485         1499              85   \n",
       "16        1486         1499              83   \n",
       "17        1486         1499              85   \n",
       "18        1486         1499              83   \n",
       "19        1486         1499              83   \n",
       "20        1486         1499             110   \n",
       "21        1486         1499             110   \n",
       "22        1486         1499             110   \n",
       "23        1486         1499             110   \n",
       "24        1486         1499             110   \n",
       "25        1486         1499              83   \n",
       "26        1486         1499              83   \n",
       "27        1486         1499              85   \n",
       "28        1486         1499              85   \n",
       "29        1486         1499              83   \n",
       "..         ...          ...             ...   \n",
       "647       1878         1000              45   \n",
       "648       1878         1342              69   \n",
       "649       1878         1000              45   \n",
       "650       1878         1342              69   \n",
       "651       1878         1342              69   \n",
       "652       1878         1000              51   \n",
       "653       1878         1000              45   \n",
       "654       1878         1342  69〔汽油〕/60〔CNG〕   \n",
       "655       1878         1000              45   \n",
       "656       1878         1342  69〔汽油〕/60〔CNG〕   \n",
       "657       1878         1342              69   \n",
       "658       1878         1000              51   \n",
       "659       1878         1000              45   \n",
       "660       1878         1342              69   \n",
       "661       1878         1342              69   \n",
       "662       1878         1000              51   \n",
       "663       1878         1000              45   \n",
       "664       1878         1342              69   \n",
       "665       1878         1000              45   \n",
       "666       1878         1342              69   \n",
       "667       1878         1000              45   \n",
       "668       1878         1342              69   \n",
       "669       1878         1000              45   \n",
       "670       1878         1000              51   \n",
       "671       1878         1342              69   \n",
       "672       1878         1000              45   \n",
       "673       1878         1000              51   \n",
       "674       1878         1342              69   \n",
       "675       1878         1000              45   \n",
       "676       1878         1000              51   \n",
       "\n",
       "                                     vin   car_factory    3 轴距[mm]  \\\n",
       "0                      LKCAA5AD×××××××××  江西昌河汽车有限责任公司  LKC   2672   \n",
       "1                      LKCAA5AD×××××××××  江西昌河汽车有限责任公司  LKC   2672   \n",
       "2                      LKCAA5AD×××××××××  江西昌河汽车有限责任公司  LKC   2672   \n",
       "3                      LKCAA5AD×××××××××  江西昌河汽车有限责任公司  LKC   2672   \n",
       "4                      LKCAA5AD×××××××××  江西昌河汽车有限责任公司  LKC   2672   \n",
       "5                      LKCAA5AD×××××××××  江西昌河汽车有限责任公司  LKC   2672   \n",
       "6                      LKCAA5AD×××××××××  江西昌河汽车有限责任公司  LKC   2672   \n",
       "7                      LKCAA5AD×××××××××  江西昌河汽车有限责任公司  LKC   2672   \n",
       "8                      LKCAA5AD×××××××××  江西昌河汽车有限责任公司  LKC   2672   \n",
       "9                      LKCAA5AD×××××××××  江西昌河汽车有限责任公司  LKC   2672   \n",
       "10                     LKCAA5AD×××××××××  江西昌河汽车有限责任公司  LKC   2672   \n",
       "11                     LKCAA5AD×××××××××  江西昌河汽车有限责任公司  LKC   2672   \n",
       "12                     LKCAA5AD×××××××××  江西昌河汽车有限责任公司  LKC   2672   \n",
       "13                     LKCAA5AD×××××××××  江西昌河汽车有限责任公司  LKC   2672   \n",
       "14                     LKCAA5AD×××××××××  江西昌河汽车有限责任公司  LKC   2672   \n",
       "15                     LKCAA5AD×××××××××  江西昌河汽车有限责任公司  LKC   2672   \n",
       "16                     LNBSCCAK×××××××××    北京汽车股份有限公司  LNB   2650   \n",
       "17                     LNBSCCAH×××××××××    北京汽车股份有限公司  LNB   2650   \n",
       "18                     LNBSCCAH×××××××××    北京汽车股份有限公司  LNB   2650   \n",
       "19                     LNBSCCAK×××××××××    北京汽车股份有限公司  LNB   2650   \n",
       "20                     LNBSCCAH×××××××××    北京汽车股份有限公司  LNB   2650   \n",
       "21                     LNBSCCAH×××××××××    北京汽车股份有限公司  LNB   2650   \n",
       "22                     LNBSCCAH×××××××××    北京汽车股份有限公司  LNB   2650   \n",
       "23                     LNBSCCAH×××××××××    北京汽车股份有限公司  LNB   2650   \n",
       "24                     LNBSCCAH×××××××××    北京汽车股份有限公司  LNB   2650   \n",
       "25                     LNBSCCAK×××××××××    北京汽车股份有限公司  LNB   2650   \n",
       "26                     LNBSCCAK×××××××××    北京汽车股份有限公司  LNB   2650   \n",
       "27                     LNBSCCAH×××××××××    北京汽车股份有限公司  LNB   2650   \n",
       "28                     LNBSCCAH×××××××××    北京汽车股份有限公司  LNB   2650   \n",
       "29                     LNBSCCAH×××××××××    北京汽车股份有限公司  LNB   2650   \n",
       "..                                   ...           ...  ...    ...   \n",
       "647  LNBMDLAA×××××××××,LNBMCVAA×××××××××    北汽银翔汽车有限公司  LNB   2630   \n",
       "648  LNBMDLAA×××××××××,LNBMCVAA×××××××××    北汽银翔汽车有限公司  LNB   2630   \n",
       "649  LNBMDLAA×××××××××,LNBMCVAA×××××××××    北汽银翔汽车有限公司  LNB   2630   \n",
       "650  LNBMDLAA×××××××××,LNBMCVAA×××××××××    北汽银翔汽车有限公司  LNB   2630   \n",
       "651  LNBMDLAA×××××××××,LNBMCVAA×××××××××    北汽银翔汽车有限公司  LNB   2630   \n",
       "652  LNBMDLAA×××××××××,LNBMCVAA×××××××××    北汽银翔汽车有限公司  LNB   2630   \n",
       "653  LNBMDLAA×××××××××,LNBMCVAA×××××××××    北汽银翔汽车有限公司  LNB   2630   \n",
       "654  LNBMDL6A×××××××××,LNBMCV6A×××××××××    北汽银翔汽车有限公司  LNB   2630   \n",
       "655  LNBMDLAA×××××××××,LNBMCVAA×××××××××    北汽银翔汽车有限公司  LNB   2630   \n",
       "656  LNBMDL6A×××××××××,LNBMCV6A×××××××××    北汽银翔汽车有限公司  LNB   2630   \n",
       "657  LNBMDLAA×××××××××,LNBMCVAA×××××××××    北汽银翔汽车有限公司  LNB   2630   \n",
       "658  LNBMDLAA×××××××××,LNBMCVAA×××××××××    北汽银翔汽车有限公司  LNB   2630   \n",
       "659  LNBMDLAA×××××××××,LNBMCVAA×××××××××    北汽银翔汽车有限公司  LNB   2630   \n",
       "660  LNBMDLAA×××××××××,LNBMCVAA×××××××××    北汽银翔汽车有限公司  LNB   2630   \n",
       "661  LNBMDLAA×××××××××,LNBMCVAA×××××××××    北汽银翔汽车有限公司  LNB   2630   \n",
       "662  LNBMDLAA×××××××××,LNBMCVAA×××××××××    北汽银翔汽车有限公司  LNB   2630   \n",
       "663  LNBMDLAA×××××××××,LNBMCVAA×××××××××    北汽银翔汽车有限公司  LNB   2630   \n",
       "664  LNBMDLAA×××××××××,LNBMCVAA×××××××××    北汽银翔汽车有限公司  LNB   2500   \n",
       "665  LNBMDLAA×××××××××,LNBMCVAA×××××××××    北汽银翔汽车有限公司  LNB   2500   \n",
       "666  LNBMDLAA×××××××××,LNBMCVAA×××××××××    北汽银翔汽车有限公司  LNB   2500   \n",
       "667  LNBMDLAA×××××××××,LNBMCVAA×××××××××    北汽银翔汽车有限公司  LNB   2500   \n",
       "668  LNBMDLAA×××××××××,LNBMCVAA×××××××××    北汽银翔汽车有限公司  LNB   2500   \n",
       "669  LNBMDLAA×××××××××,LNBMCVAA×××××××××    北汽银翔汽车有限公司  LNB   2500   \n",
       "670  LNBMDLAA×××××××××,LNBMCVAA×××××××××    北汽银翔汽车有限公司  LNB   2500   \n",
       "671  LNBMDLAA×××××××××,LNBMCVAA×××××××××    北汽银翔汽车有限公司  LNB   2500   \n",
       "672  LNBMDLAA×××××××××,LNBMCVAA×××××××××    北汽银翔汽车有限公司  LNB   2500   \n",
       "673  LNBMDLAA×××××××××,LNBMCVAA×××××××××    北汽银翔汽车有限公司  LNB   2500   \n",
       "674  LNBMDLAA×××××××××,LNBMCVAA×××××××××    北汽银翔汽车有限公司  LNB   2500   \n",
       "675  LNBMDLAA×××××××××,LNBMCVAA×××××××××    北汽银翔汽车有限公司  LNB   2500   \n",
       "676  LNBMDLAA×××××××××,LNBMCVAA×××××××××    北汽银翔汽车有限公司  LNB   2500   \n",
       "\n",
       "          长×宽×高[mm] brand_y  style  factory  \n",
       "0    4620x1810x1485    北汽昌河   昌河A6        6  \n",
       "1    4620x1810x1485    北汽昌河   昌河A6        6  \n",
       "2    4620x1810x1485    北汽昌河   昌河A6        6  \n",
       "3    4620x1810x1485    北汽昌河   昌河A6        6  \n",
       "4    4620x1810x1485    北汽昌河   昌河A6        6  \n",
       "5    4620x1810x1485    北汽昌河   昌河A6        6  \n",
       "6    4620x1810x1485    北汽昌河   昌河A6        6  \n",
       "7    4620x1810x1485    北汽昌河   昌河A6        6  \n",
       "8    4620x1810x1485    北汽昌河   昌河A6        6  \n",
       "9    4620x1810x1485    北汽昌河   昌河A6        6  \n",
       "10   4620x1810x1485    北汽昌河   昌河A6        6  \n",
       "11   4620x1810x1485    北汽昌河   昌河A6        6  \n",
       "12   4620x1810x1485    北汽昌河   昌河A6        6  \n",
       "13   4620x1810x1485    北汽昌河   昌河A6        6  \n",
       "14   4620x1810x1485    北汽昌河   昌河A6        6  \n",
       "15   4620x1810x1485    北汽昌河   昌河A6        6  \n",
       "16   4582x1794x1486    北汽绅宝  绅宝D50       22  \n",
       "17   4582x1794x1486    北汽绅宝  绅宝D50       22  \n",
       "18   4582x1794x1486    北汽绅宝  绅宝D50       22  \n",
       "19   4582x1794x1486    北汽绅宝  绅宝D50       22  \n",
       "20   4582x1794x1486    北汽绅宝  绅宝D50       22  \n",
       "21   4582x1794x1486    北汽绅宝  绅宝D50       22  \n",
       "22   4582x1794x1486    北汽绅宝  绅宝D50       22  \n",
       "23   4582x1794x1486    北汽绅宝  绅宝D50       22  \n",
       "24   4582x1794x1486    北汽绅宝  绅宝D50       22  \n",
       "25   4582x1794x1486    北汽绅宝  绅宝D50       22  \n",
       "26   4582x1794x1486    北汽绅宝  绅宝D50       22  \n",
       "27   4582x1794x1486    北汽绅宝  绅宝D50       22  \n",
       "28   4582x1794x1486    北汽绅宝  绅宝D50       22  \n",
       "29   4582x1794x1486    北汽绅宝  绅宝D50       22  \n",
       "..              ...     ...    ...      ...  \n",
       "647  4022x1600x1878    北汽威旺  威旺205       10  \n",
       "648  4022x1600x1878    北汽威旺  威旺205       10  \n",
       "649  4022x1600x1878    北汽威旺  威旺205       10  \n",
       "650  4022x1600x1878    北汽威旺  威旺205       10  \n",
       "651  4022x1600x1878    北汽威旺  威旺205       10  \n",
       "652  4022x1600x1878    北汽威旺  威旺205       10  \n",
       "653  4022x1600x1878    北汽威旺  威旺205       10  \n",
       "654  4022x1600x1878    北汽威旺  威旺205       10  \n",
       "655  4022x1600x1878    北汽威旺  威旺205       10  \n",
       "656  4022x1600x1878    北汽威旺  威旺205       10  \n",
       "657  4022x1600x1878    北汽威旺  威旺205       10  \n",
       "658  4022x1600x1878    北汽威旺  威旺205       10  \n",
       "659  4022x1600x1878    北汽威旺  威旺205       10  \n",
       "660  4022x1600x1878    北汽威旺  威旺205       10  \n",
       "661  4022x1600x1878    北汽威旺  威旺205       10  \n",
       "662  4022x1600x1878    北汽威旺  威旺205       10  \n",
       "663  4022x1600x1878    北汽威旺  威旺205       10  \n",
       "664  3895x1600x1878    北汽威旺  威旺205        4  \n",
       "665  3895x1600x1878    北汽威旺  威旺205        4  \n",
       "666  3895x1600x1878    北汽威旺  威旺205        4  \n",
       "667  3895x1600x1878    北汽威旺  威旺205        4  \n",
       "668  3895x1600x1878    北汽威旺  威旺205        4  \n",
       "669  3895x1600x1878    北汽威旺  威旺205        4  \n",
       "670  3895x1600x1878    北汽威旺  威旺205        4  \n",
       "671  3895x1600x1878    北汽威旺  威旺205        4  \n",
       "672  3895x1600x1878    北汽威旺  威旺205        4  \n",
       "673  3895x1600x1878    北汽威旺  威旺205        4  \n",
       "674  3895x1600x1878    北汽威旺  威旺205        4  \n",
       "675  3895x1600x1878    北汽威旺  威旺205        4  \n",
       "676  3895x1600x1878    北汽威旺  威旺205        4  \n",
       "\n",
       "[677 rows x 17 columns]"
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "LSG_price = LSG_price[(LSG_price['长×宽×高[mm]']!='')|(LSG_price['长×宽×高[mm]']!=None)]\n",
    "LSG_price['curb_weight'] =LSG_price['整备质量[kg]']\n",
    "LSG_price = LSG_price.groupby(['轴距[mm]','长×宽×高[mm]','brand','style'])['factory'].count().reset_index()\n",
    "LSG_price = LSG_price.drop([77,121,122,123])\n",
    "LSG_price['car_length'] = LSG_price['长×宽×高[mm]'].apply(lambda x:x.split('x')[0])\n",
    "LSG_price['car_width'] = LSG_price['长×宽×高[mm]'].apply(lambda x:x.split('x')[1])\n",
    "LSG_price['car_height'] = LSG_price['长×宽×高[mm]'].apply(lambda x:x.split('x')[2])\n",
    "LSG_price['Wheelbase'] =LSG_price['轴距[mm]']\n",
    "\n",
    "LSG.merge(LSG_price,on=['car_length','car_width','Wheelbase','car_height'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {},
   "outputs": [],
   "source": [
    "result = LSG.merge(LSG_price,on=['car_length','car_width','Wheelbase','car_height'])\n",
    "import re\n",
    "vin1 = []\n",
    "for a,i in result.iterrows():\n",
    "    a = re.findall(r'L[0-9A-Za-z]{7}×××××××××',i['vin'])\n",
    "    for j in a:\n",
    "        vin = []\n",
    "        vin.append(j)\n",
    "        vin.append(i['car_factory'].split(',')[0])\n",
    "        vin.append(i['brand_y'].split(',')[0])\n",
    "        vin.append(i['style'].split(',')[0])\n",
    "        vin1.append(vin)\n",
    "vin = pd.DataFrame(vin1,columns=['vin','car_factory','brand','style'])\n",
    "vin = vin.drop_duplicates()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {},
   "outputs": [],
   "source": [
    "vin.to_csv('北京.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
